System and method for implementing privacy preferences and rules within an e-business data warehouse

ABSTRACT

A computer implemented method of and apparatus for collecting and managing customer related information within an E-Business customer relationship management system. The customer relationship management system includes a database in which customer-related information, as well as privacy policy and privacy consent information governing the collection and use of customer related information, is stored and organized. The database includes tables containing privacy consent default values for customers of the E-Business retailer high-level privacy consent values selected by the customers; specific privacy consent values selected by the customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and privacy consent values selected by the customers for different customer addresses. In the situation where customer or potential customer include minor children, the database includes a database table containing parental privacy consent values for said children under thirteen years of age.

CROSS REFERENCE TO RELATED APPLICATIONS

This application is related to the following co-pending andcommonly-assigned patent applications, which are incorporated byreference herein:

Application Ser. No. 09/990,539, entitled “SYSTEM AND METHOD FORCAPTURING AND STORING INFORMATION CONCERNING WEB VISITOR BROWSINGACTIVITIES IN A DATA WAREHOUSE”; filed on Nov. 16, 2001 by Scott D.Carty, Sylvie F. Haddad and Tucker Smith.

Application Ser. No. 09/992,571, entitled “SYSTEM AND METHOD FORCAPTURING AND STORING INFORMATION CONCERNING OPERATIONAL METRICS OF ABUSINESS WEB SERVER AND WEB SITE”; filed on Nov. 16, 2001 by Scott D.Carty, Sylvie F. Haddad, and Tucker Smith.

Application Ser. No. 09/990,541, entitled “SYSTEM AND METHOD FORCAPTURING AND STORING WEB SITE VISITOR PROFILE INFORMATION IN A DATAWAREHOUSE”; filed on Nov. 16, 2001 by Scott D. Carty, Sylvie F. Haddad,and Tucker Smith.

Application Ser. No. 09/990,634, entitled “SYSTEM AND METHOD FORCAPTURING AND STORING INFORMATION CONCERNING ON-LINE ADVERTISINGCAMPAIGNS, PROMOTIONS, AND ADVERTISEMENTS OF AN E-BUSINESS RETAILER”;filed Nov. 16, 2001 by Scott D. Carty and Tucker Smith.

Application Ser. No. 09/990,902, entitled “SYSTEM AND METHOD FORCAPTURING AND STORING OPERATIONAL DATA CONCERNING AN INTERNET SERVICEPROVIDER'S (ISP) OPERATIONAL ENVIRONMENT AND CUSTOMER WEB BROWSINGHABITS”; filed on Nov. 16, 2001 by Scott D. Carty and Tucker Smith.

FIELD OF THE INVENTION

The present invention relates generally to a Customer RelationshipManagement System for an E-Business retailer, and more particularly, toa system and method in which the collection and use of customerinformation is governed by specific privacy consent information obtainedfrom customers of the E-Business retailer. Still more particularly, thepresent invention is related to a logical data model that defines thestructure for storing and organizing privacy policy and privacy consentinformation within an E-Business customer relationship managementsystem.

BACKGROUND OF THE INVENTION

As the World Wide Web evolves into an increasingly dynamic channel formarketing and commerce, web sites are becoming mission-criticalcomponents of overall business strategies. Sophisticated businesses nolonger view the web as a venue of relatively anonymous transactions, butas a crucial point of contact between the business and its customers—aplace where lasting customer relationships can be forged and maintained.Businesses realize that, at each point of customer contact, significantamounts of data are being gathered and stored. The data from thesedisparate systems needs to be sorted, merged and coalesced intomeaningful business information.

Companies for whom the Internet is a primary, if not the primary,conduit for managing customer relationships have invested heavily intheir online businesses. To measure the return on this investment, andmake the most of the web-marketing channel, managers need an E-BusinessData Warehouse solution that can provide answers to the following typesof questions:

-   -   Who are our best prospects and why?    -   Where are our most profitable customers coming from . . . which        of our partner refers them to our site?    -   Which of our banner ad campaigns is driving the most qualified        traffic to our site?    -   Which banner ad is generating the most revenue?    -   Which banner ad has the best buy versus browse ratio?    -   Which products are selling best online and why?    -   How many new or repeat visitors come to our site in a given time        period?    -   What is the percentage and total number of new customers,        existing customers, browsers for a given time period?    -   What is the conversion ratio for all customers coming to the        site, by referral, by customer segment?    -   What is the average number of browse sessions prior to first        purchase, second purchase, . . . nth purchase, by customer        segment over a given time frame?

Whereas the success of a company's web site was once measured in hitsand page views, with the web master as primary audience for reportsbased on those metrics, the performance and information obtained fromthe web site is now critical to many members of the organization. Toanswer questions like the samples above, an E-Business Data Warehousesolution must be able to correlate click stream data with data fromother disparate sources and transform it into actionable informationavailable to users throughout the Enterprise.

While understanding online customers is necessary for an E-Businesscompany's success, and extracting business information from web sitetraffic is imperative, web site complexity is growing exponentially.Today's complex web sites often employ geographically distributedservers and a mix of solutions, e.g., Ad Servers, Application Servers,Profile Servers, Content Management Systems and various Personalizationtechnologies, to offer visitors a richer, more dynamic personalexperience in the hope of turning those visitors into loyal customers.In addition, more and more companies are moving traditional businessapplications to the web and linking back-office systems to their onlineenvironments. These complex information architectures linking intranets,extranets and the Internet create vast amounts of raw data. Theresulting site complexity, disparate data sources, and data volumesmakes accurate and complete customer analysis difficult to impossiblefor most vendor solutions.

NCR Corporation has developed an E-Business Data Warehouse solution toprovide the answers, embedded in this complex E-Business environment, toquestions about online customers. NCR Corporation's E-Business Datawarehouse solution, referred to herein as the Teradata Solutions forE-Business (TSEB), provides the decision support engine and surroundingtechnology to turn disparate customer information into knowledge. Theability to easily handle large amounts of data coupled with the abilityto integrate data from many sources allows NCR Corporation to providethe most robust and scalable complete E-Business Data Warehouse Solutionavailable in the industry.

Within any system including a depository of customer-relatedinformation, protection of personal privacy and customer privacypreferences is an important concern. Currently, there is no uniform setof laws, regulations, or conventions for E-Businesses to apply towardthis problem. On the contrary, there are very different laws,conventions, and standards in play throughout the world—particularlybetween the United States and Europe. Following is a very brief summaryof the latest versions of such regulations.

P3P or Platform for Privacy Preference was developed by the World-WideWeb Consortium (W3C). It, is the emerging US standard. It provides astandard XML based schema for defining a Web Site Privacy policy, apersonal profile and personal privacy rules as well as a protocol to beused by privacy agent software to negotiate between a site and aconsumer. P3P defines 15 basic privacy categories. Consumer consent canbe given at the category level or at a more granular element level.

The Children Online Privacy Privacy Protection Act (COPPA) was developedby the Federal Trade Commission (FTC). It went into law on Oct. 21,1998. It requires certain commercial sites to get explicit verifiableparental consent before collecting, using or disclosing personalinformation from children under 13. The sites must also prominentlydisplay their privacy policy which states what data is being collectedand how it will be used.

The European Directive 95/46/EC, supplemented in 97/66/EC providesEuropean consumers with rights relative to notice, explanation of thelogic behind automatic processing, correction/deletion/blocking and theright to object. It also imposes responsibilities on the dataadministrators to only keep the data as long as necessary, preventunauthorized access, insure data accuracy etc. In the case of sensitivedata such as racial/ethnic, political, religious, philosophical, etc.the EU directive requires an explicit opt-in. Additionally it offers theconsumers the right to opt-out of Automated Decisions.

The standards distinguish between different types of consent: DirectMarketing, 3^(rd) party disclosure, and Affiliate disclosure. The EUadds Sensitive Data consent (explicit opt-in) and Automated decisioncode.

On Jul. 27, 2000 the Network Advertising Initiative (NAI) with thesupport of the FTC announced an agreement that requires explicit opt-infor the merger of Personally Identifiable Information (PII) withpreviously collected non-PII. They also agreed not to use PII aboutsensitive data (medical, financial etc). This agreement has implicationon the Data Warehouse privacy design as well.

The above standards do not guarantee that the E-Commerce companies areactually executing on their policies as stated. The Online PrivacyAlliance, of which NCR is a founding member, encourages the use ofindependent privacy auditors who assess the business' conformance to itspublished privacy policy. These companies, such as TRUSTe and BBBOnline, award a business a “Seal of Compliance” when their privacypractices are in conformance. Auditing requires tracking of historicalconsent code updates.

What is needed is an extensible solution that can encompass known lawsand standards and dynamically control access to personal informationthat may be used by analytical applications, e.g., reports, statisticalmodels, etc. For example, the solution should limit access to personalinformation on minors for an application executing in the United States,but would need to enable access to that information to that sameapplication executing in a European county.

SUMMARY OF THE INVENTION

It is an object of the present invention to provide a system and methodfor capturing, storing and using customer information within anE-Business customer relationship management system.

It is a further object of the present invention to provide such a systemand method in which the collection and use of customer information isgoverned by privacy consent information obtained from customers of theE-Business retailer.

It is a still further object of the present invention to provide alogical data model that defines the structure for storing and organizingprivacy policy and privacy consent information within an E-Businesscustomer relationship management system.

The foregoing objects are accomplished through utilization of a databasesystem for storing and managing information obtained from and aboutcustomers and potential customers of an E-Business retailer. Data isstored within a database in accordance with an E-Business logical datamodel which defines the manner in which customer related information, aswell as privacy policy and privacy consent information governing thecollection and use of customer related information, is stored andorganized within a database. The database includes a database tablecontaining privacy consent default values for customers of theE-Business retailer; a database table containing high-level privacyconsent values selected by the customers; a database table containingprivacy consent values selected by the customers for a plurality ofprivacy categories defined by the Platform for Privacy Preference (P3P);and a database table containing privacy consent values selected by thecustomers for different customer addresses. In the situation wherecustomers or potential customer include minor children, the database mayfurther include a database table containing parental privacy consentvalues for said children under thirteen years of age.

In the preferred embodiment, the database system also includes databasetables containing histories of changes to the tables containing privacyconsent default values, high-level privacy consent values, the specificprivacy consent values related to Platform for Privacy Preference (P3P),the privacy consent values related to a customer's different addresses,and the parental privacy consent values for said children under thirteenyears of age. Customer privacy consent and consent history informationis organized within the database tables in accordance with a PRIVACYsubject area within the E-Business logical data model.

Still other objects and advantages of the present invention will becomereadily apparent to those skilled in the art from the following detaileddescription, wherein the preferred embodiments of the invention areshown and described, simply by way of illustration of the best modecontemplated of carrying out the invention. As will be realized, theinvention is capable of other and different embodiments, and its severaldetails are capable of modifications in various obvious respects, allwithout departing from the invention. Accordingly, the drawings anddescription thereof are to be regarded as illustrative in nature, andnot as restrictive.

BRIEF DESCRIPTION OF THE DRAWINGS

The present invention is illustrated by way of example, and not bylimitation, in the Figures of the accompanying drawings, whereinelements having the same reference numeral designations represent likeelements throughout and wherein:

FIG. 1 is a block diagram illustration of an operational architecture ofthe Teradata Solutions for E-Business in accordance with the presentinvention.

FIG. 2 is a high level illustration of a system architecture of theTeradata Solutions for E-Business in accordance with the presentinvention.

FIG. 3 is a subject area model of an E-Business industry logical datamodel, illustrating the subject areas included within the LDM, inaccordance with the preferred embodiment of the present invention;

FIGS. 4A and 4B illustrate an entity-relationship diagram of the ADsubject area of the logical data model in accordance with the preferredembodiment of the present invention;

FIGS. 5A and 5B illustrate an entity-relationship diagram of theCALENDAR DATE subject area of the logical data model in accordance withthe preferred embodiment of the present invention;

FIGS. 6A and 6B illustrate an entity-relationship diagram of the CONTACTINFORMATION subject area of the logical data model in accordance withthe preferred embodiment of the present invention;

FIGS. 7A through 7E illustrate an entity-relationship diagram of theINTERNET SERVICE PROVIDER (ISP) subject area of the logical data modelin accordance with the preferred embodiment of the present invention;

FIGS. 8A through 8E illustrate an entity-relationship diagram of theITEM subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIGS. 9A and 9B illustrate an entity-relationship diagram of theLOCATION subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIG. 10 is an entity-relationship diagram of the MULTIMEDIA COMPONENTsubject area of the logical data model in accordance with the preferredembodiment of the present invention;

FIGS. 11A through 11F illustrate an entity-relationship diagram of thePRIVACY subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIGS. 12A through 12G illustrate an entity-relationship diagram of thePROFILE subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIGS. 13A and 13B illustrate an entity-relationship diagram of thePROMOTION subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIG. 14 is an entity-relationship diagram of the TIME subject area ofthe logical data model in accordance with the preferred embodiment ofthe present invention;

FIGS. 15A thorough 15E illustrate an entity-relationship diagram of theTRANSACTION ACTIVITY subject area of the logical data model inaccordance with the preferred embodiment of the present invention;

FIGS. 16A and 16B illustrate an entity-relationship diagram of theVENDOR subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIGS. 17A through 17F illustrate an entity-relationship diagram of theVISIT subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIGS. 18A through 18E illustrate an entity-relationship diagram of theVISITOR subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

FIG. 19 is an entity-relationship diagram of the WEB SERVER subject areaof the logical data model in accordance with the preferred embodiment ofthe present invention;

FIGS. 20A and 20B illustrate an entity-relationship diagram of the WEBVISIT subject area of the logical data model in accordance with thepreferred embodiment of the present invention;

BEST MODE FOR CARRYING OUT THE INVENTION

FIG. 1 illustrates the operational architecture of the TeradataSolutions for E-Business. Components of the architecture shown includeexternal operational databases 107, web logs 111 and extraction,translation and loading (ETL) tools 109 and 113 for extracting data fromthe data sources 107 and 111, respectively, and preprocessing theextracted data for entry into the data warehouse. The data warehouse 101includes staging tables 115, ETL tools 117, an E-Business database 103organized in accordance with an E-Business LDM 105, E-Advertiser andE-Business Dimensional Data Models 119 that support the creation ofreports, and an E-Advertiser and E-Business Metadata Database 127providing report definitions (templates, filters, etc.) and dimensionalmodel-to-data warehouse mapping.

In the operational architecture shown in FIG. 1, Dimensional Data Models119 and Metadata Database 127 are components of MicroStrategyIncorporated Decision Support System (DSS) software toolset. These twocomponents work together with external MicroStrategy DSS servercomponents 121 and MicroStrategy applications 123 and 125 to create andmodify E-Business and web site reports.

Operational data 107 and web logs 111 are loaded into the staging tableson a regular basis, using extraction, transformation, and loading (ETL)tools 109 and 113, respectively. The data is then transferred from thestaging tables 115 to the TSEB LDM physical database 103 using ETL tools117. The MicroStrategy DSS tools, used to analyze the data in the TSEB,require a star schema database to create multidimensional reports. Tocreate this schema, a dimensional LDM 119 is defined using views andtables in the TSEB physical database.

The operational data, i.e. filters, templates and reports, forMicroStrategy is contained in the metadata database 127. This databaseis created using a MicroStrategy SQL Script, and populated with projectinformation via MicroStrategy Architect 125 and Agent 123. When one ofthe MicroStrategy applications performs a function that accesses thedimensional LDM, the appropriate information is extracted from themetadata database.

FIG. 2 illustrates a system architecture for the Teradata Solutions forE-Business. The main components of the TSEB solution are:

-   -   Teradata warehouse running on an NCR UNIX SVR4 MP-RAS or a        Windows NT server 201; and    -   Analysis and data mining applications running on a separate        Windows NT server 207.

The TSEB configuration should be implemented as a two-tier (minimum) orthree-tier (preferable for databases more than 3 GB) architecture. TheTeradata data warehouse 101, for security and performance, should run ona remote server 201 and the other components run on separate servers.Other components may include an NT or UNIX server 203 for housingoperational database 107, a web server 205 for housing web logs 111, andan NT server 207 and NT or Windows client workstation 209 supportingMicroStrategy server components 121 and applications 123 and 125.

The source of the data that will be stored in the data warehouse dependsupon the type of business for which the warehouse is being implemented.At a retail site, customer data will come from the business' operationaldatabase, web interaction data will come from the business's web logs,and transactional and product data will come from the business' commercedatabase. For an ISP support business (such as an E-Advertiser),customer data will come from registration and purchase information. Webdata will come from web logs gathered from many sites, and transactionaldata will come from many businesses.

Logical Data Model Design Basics

A logical data model (LDM) is an abstract construct that is physicallyrealized in the database or data warehouse. The data model provides anarchitecture for the information that will be included in a datawarehouse. The database provides the physical realization of thatarchitecture in a form that can be efficiently maintained and used.There may well be some differences between the logical data model andthe final database design. The database may include some tables (summarytables, etc.) or columns that have no direct correlation in the logicaldata model. Elements in the logical model may be grouped differently inthe physical database.

A logical data model is organized by Subject Areas, each comprised ofnumerous Entities, Attributes and Relationships. The data modelhierarchy includes one or more Subject Areas. Each Subject Area includesone or more Entities or Tables, each having Attributes andRelationships. Each Attribute describes a fact about an Entity.Relationships between two or more Entities are further defined byCardinality. The Relationships define which entities are connected toother entities and the cardinality of the relationships. Each of theseelements will be described in greater detail below.

Subject Area

A subject area is a subset of objects taken from the universe of dataobjects for a particular line of business or industry that focus on aparticular Business Process. Typically, a subject area is created tohelp manage large data architectures that may encompass multiplebusiness processes or business subjects. This is the highest-level dataconcept within a conceptual entity/relationship (E/R) model. Workingwith subject areas is especially useful when designing and maintaining alarge or complex data model. Dividing the enterprise into severaldistinct subject areas allows different groups within an organization toconcentrate on the processes and functions pertinent to their businessarea.

Entity

An Entity represents a person, place, thing, concept, or event (e.g.PARTY, ACCOUNT, INVOICE, etc.). It represent something for which thebusiness has the means and the will to collect and store data. An Entitymust have distinguishable occurrences, e.g., one must be able touniquely identify each occurrence of an entity with a primary key (e.g.Party Identifier, Account Identifier, Invoice Number, etc.). An Entityis typically named with a unique singular noun or noun phrase (e.g.,PARTY, BILLING STATEMENT, etc.) that describes one occurrence of theEntity and cannot be used for any other Entity. It should be exclusiveof every other Entity in the database. An Entity cannot appear more thanonce in the conceptual entity/relationship (E/R) model. Each Entity mayhave relationships to other Entities residing in its own Subject Area orin other Subject Areas.

Attribute

An Attribute is a data fact about an Entity or Relationship. It is alogical (not physical) construct. It is data in its atomic form. Inother words, it is the lowest level of information that still hasbusiness meaning without further decomposition. An example would beFIRST NAME, or LAST NAME. An example of an invalid attribute would bePERSON NAME if it includes both the first and last names, as this couldbe further decomposed into the separate, definable (first name, lastname) data facts.

Relationship

A Relationship is an association that links occurrences of one or moreEntities. A Relationship must connect at least one Entity. If only oneEntity is connected, the Relationship is said to be Recursive. ARelationship is described by a noun or passive verb or verb phase thatdescribes the action taken in the Relationship. A Relationship representa static state of being between the occurrences of the Entities itconnects. Relationships are not intended to represent processes or dataflows. They cannot be linked to another Relationships. They mayoptionally represent future, present, and/or past relatedness. The timeframe must be explicitly defined in the data definition. Relationshipsmay contain attributes. In a normalized model, a Relationship containingAttributes will result in the creation of an Entity.

Cardinality

In order for a data model to be considered accurate, it must containboth the maximum and minimum number of Entity occurrences expected. Thisis controlled by rules of cardinality, which describes a relationshipbetween two Entities based on how many occurrences of one Entity typemay exist relative to the occurrence of the other Entity. Typically, itis a ratio, commonly depicted as a one-to-one (1:1); one-to-many (1:N);and many-to-many (M:N) relationship.

The maximum cardinality may be an infinite number or a fixed number butnever zero. The minimum cardinality may be zero, or some other positivenumber, but it must be less than or equal to the maximum cardinality forthe same relationship.

The logical data model for the E-Business will now be described in moredetail. The logical data model uses IDEFIX modeling conventions, asshown in Table 1.

TABLE 1 Entity Conventions Convention Definition

Independent entity. An entity is depicted as a box, with its name abovethe box in singular, uppercase form. Square-boxed entities areindependent. They rely on no other entity for their identification.Primary keys are attributes that uniquely identify the entity. Primarykeys are shown at the top of the box, separated from other listedattributes by a hori- zontal line.

Dependent entity. Round-cornered entities are dependent on one or moreentities for their identifi- cation. (FK) following the primary keyattribute indicates a foreign key - an attribute in the entity that isthe primary key in another, closely related entity.

An independent entity may also include a foreign key as a “non-primarykey foreign key”. A non- primary key foreign key is shown below thehori- zontal line separating primary key attributes from other entityatributes.Relationship and cardinality conventions are shown in Table 2.

TABLE 2 Relationship/Cardinality Conventions Convention Definition

A single line at the end of a relationship link means that a singlerecord entity B is related to only one record in entity A.

A circle indicates that the presence of a linked record in entity A isoptional.

A double line indicates that the presence of a linked record in entity Ais mandatory.

One-to-one relationship.

One-to-many relationship. The crow's foot symbol means that more thanone instance of an entity is associated with another entity.

One-to-one-or-more relationship. A crossbar with a crow's foot symbolmeans there is at least one instance of an entity associated with theother entity.

One-to-zero-one-or-more relationship. A circle with a crow's feet symbolmeans there may be zero, one, or many instances of the entity associatedwith the other entity.

A dotted relationship line indicates that the identity of entity B isnot linked to entity A.

E-Business Logical Data Model

The E-Business Logical Data Model is a large data model composed of alarge number of tables. To effectively view and understand the datamodel, the data tables have been logically organized into smaller groupscalled subject areas. Each subject area is comprised of a set of tablesthat contain information relevant to a particular entity. In addition,the subject areas address particular business questions.

FIG. 3 is a subject area model of the E-Business logical data model,illustrating the subject areas included within the LDM. The Subject AreaModel is a one-page overview that defines, at a high level, the scopeand data requirements of the solution. Each subject area within thelogical data model will be illustrated in the Figures and described ingreater detail below.

The subject area model shown in FIG. 3 illustrates some of the majorrelationships between subject areas. The boxes represent the subjectareas. Each line represents a relationship between subject areas. Thesolid circle at the end of a relationship line represents the target ofa ‘many’ relationship. An open circle at the end of a relationship lineindicates that the relationship is optional.

The E-Business LDM is organized into seventeen major subject areastitled: AD, CALENDAR DATE, CONTACT INFORMATION, ISP, ITEM, LOCATION,MULTIMEDIA COMPONENT, PRIVACY, PROFILE, PROMOTION, TIME, TRANSACTIONACTIVITY, VENDOR, VISIT, VISITOR, WEB SERVER, WEB SITE. All but theCALENDAR DATE and TIME subject areas, with relationships to all of theremaining subject areas, are shown in FIG. 3. All of the subject areasare illustrated detail in FIGS. 4 through 20, discussed below.

A brief description of each subject area follows:

AD (301)—Determines the effectiveness of ad campaigns by collectinginformation on the cost of ads by type, and comparing this informationwith the number of times an exposure to the ad delivered a customer to aparticular item or site.

CALENDAR DATE (not shown)—Information is tracked by date and season.Holidays are tracked by country.

CONTACT INFORMATION (305)—Stores contact information for customers &organizations, including mailing addresses, email addresses, andtelephone numbers.

ISP (307)—The ISP component view covers all aspects of Internet ServiceProvider activity.

ITEM (309)—Information is tracked on each piece of merchandise orservice. Included would be a description, how the item was classified,price, cost, the number in inventory, etc.

LOCATION (311)—Information is stored on all physical and virtual sitesowned or leased by the retailer to support the sale of goods,distribution, and storage. Would include kiosks, warehouses, offices, aswell as internet sites.

MULTIMEDIA COMPONENT (313)—Stores multimedia elements that can be use toconstruct a web page, such as ads, catalogues, etc.

PRIVACY (315)—Stores information about privacy permissions fromindividuals, households and organizations of interest to the enterprise.

PROFILE (317)—Stores information concerning customer segments ofinterest to the enterprise. This information is typically purchased froma third party.

PROMOTION (319)—Contains information concerning promotions, which aredefined as marketing efforts, which are different from normal practiceand designed for a specific purpose. Information is stored on thevarious components of the promotion, including the items and adsincluded, the type of ad, and the market segments targeted.

TIME (not shown)—Records the time in a given day by hours, minutes andseconds.

TRANSACTION ACTIVITY (323)—Stores information concerning a customer'sinteraction with the company involving the sale or return of an item andthe price and discounts associated with that item. It maps customers toentries in the Address Area, the item(s) of interest, and the associatedealing with the customer.

VENDOR (325)—Stores information about parties from which the companypurchases goods and services. This would include information concerningpurchase orders, returns, and items shipped directly to the company ordrop shipped to a customer.

VISIT (327)—Stores information concerning a customer's history at avirtual store's web site. Included would be information about the adsthat triggered the visit, the web pages browsed, and the items ofinterest to the consumer.

VISITOR (329)—Captures information about the users involved in webtransactions and/or interactions. This area maintains information aboutcustomer's payment accounts, and household and organizationalaffiliations, and it maps customers to entries in the Profile SubjectArea.

WEB SERVER (331)—Provides summary information, operational metrics anderrors about the physical server devices servicing a given web visit bya customer.

WEB SITE (333)—Stores information about the company's web sitesincluding page components, page generation, and web page type.

The E-Business Logical Data Model is intended to be generic so that awide range of business situations is encompassed. In general, the modelreflects major business objects in a retail electronic store, such asproducts, people, service requests, and market baskets. There are also avariety of subject areas relating to customer sessions that involvebrowsing, purchasing, or interacting with employees. All subject areainformation need not be present for the model to be useful. For manytypes of businesses, all of the subject areas in the model will notapply.

The tables in a subject area represent the logical subset of tables inthe data model that provide all the information for the subject area.Note how that a specific table may appear in multiple subject areas. Forexample, the CONTACT INFO table appears in the CONTACT INFORMATION andPRIVACY subject areas. This means that the information in the CONTACTINFO table is relevant to each of those subject areas; each subject arearefers to the same physical item table.

Each Subject area and its Entities will now be described in detail.

AD

The AD Subject Area, shown in the diagram of FIGS. 4A and 4B, is used todetermine the effectiveness of ad campaigns by collecting information onthe cost of ads by type, and comparing this information with the numberof times an exposure to the ad delivered a customer to a particular itemor site.

The entities of the AD Subject Area are defined as follows:

AD (403) A marketing message aimed at a segment of consumers. Usuallymentions specific ITEMs. Can be placed in magazines, on web pages,television, etc.

AD CONTENT (405) This entity represents the subject matter contained inan AD.

AD IMPLEMENTATION (406) An instantiation of the marketing messagerepresented by the parent AD entity.

AD IMPLEMENTATION TYPE (407) This entity represents the type of the ADIMPLEMENTATION. Types include WEB AD, BANNER AD, EMAIL AD, HTML TEXT AD,PRINT AD, TV AD.

AD IMPLEMENTATION X ITEM (408) This table associates items with an adimplementation.

AD IMPLEMENTATION X WEB VISIT (409) This entity represents therelationship between an AD IMPLEMENTATION and a WEB VISIT providing theinformation for determining which AD initiated the WEB VISIT. Thisrepresents the Referral to the site.

AD PLACEMENT (410) The entity represents a particular instance of an ADIMPLEMENTATION when an ad is actually displayed to a consumer on a webpage.

AD PLACEMENT CONTRACT (411) The entity represents the agreement madebetween the ad service provider and the advertiser that states the timeperiod for the contract, the number of impressions and click-throughsguaranteed to the advertisers and the cost for each impression andclick-through.

AD PROVIDER (412) This entity represents the business that works withthe advertisers and publishers to actually get the advertisements andplace them on the publishing web sites. This entity represents thecompany that provides the service for placing Ads.

AD PROVIDER CONTACT INFO (413) Contains information regarding theaddress of an Ad Provider.

AD PROVIDER TYPE (414) Information regarding the type of Ad provider.

AD RESPONSE (415) This entity represents an action taken in response toan AD PLACEMENT.

AD RESPONSE TYPE (416) This entity represents the type of an AD RESPONSEwhich can be either IMPRESSION, CLICKTHROUGH, or CONVERSION.

AD SIZE (417) This entity represents the size of a BANNER AD by thenumber of pixels. Examples of AD SIZES include Full Banner (468×60) andVertical Banner (120×240).

CONTRACT LOCATION (455) The stores/Web Sites that are covered by thiscontract.

DELETE STATUS (473) Customer Domain: Indicates if row is deleted oractive.

ONLINE STATUS (571) Customer Domain: Whether the ad is online or offline

CALENDAR DATE

FIGS. 5A and 5B illustrate an entity-relationship diagram of theCALENDAR DATE subject area of the E-Business logical data model. TheCALENDAR DATE Subject Area contains information tracked by date andseason. Holidays are tracked by country.

The entities of the CALENDAR DATE Subject Area are defined as follows:

CALENDAR DATE (424) Allows for the grouping of Gregorian dates by anyperiod defined by the enterprise. The attributes shown here representpossible rollup periods.

CALENDAR DATE X HOLIDAY (425) This entity serves as a relationship tablebetween CALENDAR DATE and HOLIDAY to represent the many-to-manyrelationship.

CALENDAR DATE X SPECIAL EVENT (426) This entity represents therelationship table between CALENDAR DATE and SPECIAL EVENT to representthe many-to-many relationship.

DAY OF WEEK (472) This entity represents the names of the days in a week(Sunday, Monday . . . ).

HOLIDAY (496) A declared non-working day. Differs by Country. Examplesinclude Christmas, New Years Day, Bastille Day, Independence Day, etc.

LAST YEAR DATE (547) Provides a specific reference to a previous yearsdate to the current date.

MONTH TO DATE (559) Provides a specific reference for a month to thecurrent date.

MONTHS (560) This entity represents the months of the year. The idcolumn uniquely identifies a month by including the number of the monthin the year (1-12) and the year it belongs in. Example: 011999. Thedescription column is the actual name of the month.

QUARTERS (620) This entity represents the quarters of a year. A QUARTERis uniquely identified by a quarter number (1-4) and the year. Example:041999.

SEASON (635) A contiguous period of time of interest to the enterprise.Can be climate and/or marketing based. Examples include Summer,‘Christmas season’, etc.

SPECIAL EVENT (644) This entity represents a day or group of days that acertain notable event occurred on. Examples include Super Bowl Sundayand Hurricane Hugo.

WEEKS (700) This entity represents the weeks of a year. The uniqueidentifier for a WEEK consists of the week number (1-52) combined withthe year in which the week occurs. Example: 521999.

YEAR TO DATE (701) Provides a reference of a specific date to thecurrent date.

YEARS (702) The entity represents a calendar year.

CONTACT INFORMATION

The CONTACT INFORMATION Subject Area, illustrated in theentity-relationship diagram of FIGS. 6A and 6B, stores contactinformation for customers & organizations, including mailing addresses,email addresses, and telephone numbers.

The entities of the CONTACT INFORMATION Subject Area are defined asfollows:

CENSUS BLOCK (429) A grouping of ADDRESSes used by the government forcensus statistics. Usually a subset of POSTAL CODE.

The number of three family household in a small geographical area,according to 1998 census data.

CITY (435) A geographical region within a TERRITORY. Can also be ahamlet, village, township, etc. Examples include: Los Angeles, Dijon,etc.

CONTACT INFO (448) A way to communicate with, or contact, PARTYs. It canbe MAIL ADDRESS (P.O. Box, or street), ELECTRONIC ADDRESS, or TELEPHONEnumber:

CONTACT INFO STATUS (449) Indicates whether the address is still validor not.

CONTACT INFO TYPE (450) Indicates if an ADDRESS is MAIL, ELECTRONIC, orTELEPHONE.

CONTACT INFO USAGE (451) Specifies the usage of an address.

COUNTRY (461) A geographical-political region with sovereign governing.

COUNTRY TYPE (462) Contains information about country types.

COUNTY (463) A geographic region within a TERRITORY. Example: LosAngeles County.

ELECTRONIC ADDRESS (481) A non-physical/virtual ADDRESS. Could be ane-mail, ftp, URL, etc.

LOCATION CONTACT INFO (550) Describes how a specific combination ofADDRESS and LOCATION is used. For example, ‘123 Main Street’ is used by‘Distribution Center 23’ as ‘Ship To’; ‘310-555-2342’ is used by ‘CallCenter 46’ as ‘Customer Service Fax number’.

MAIL ADDRESS (556) An ADDRESS where ITEMs can physically be deliveredto. For example: 123 Main Street, P.O. Box 2001, etc.

MSA (561) Metropolitan Statistical Area. Predefined geographic areas formarketing use, center around large metropolitan areas. Such as: MiamiMSA, San Francisco MSA, etc.

PARTY CONTACT INFO (585) Describes how a specific combination of ADDRESSand PARTY is used. For example: ‘123 Main Street’ is used by ‘Rachel’ as‘Ship To’; ‘310-555-2342’ is used by ‘J ohn’ as ‘Fax number’.

PARTY GEOCODE (587) Contains detail contact information for a specificparty entity. This table is present to support NCR's CustomerRelationship Management (CRM) application.

POSTAL CODE (609) A grouping of MAIL ADDRESSes assigned by the PostOffice. Frequently used in marketing analysis and planning. Examplesinclude USA: 90210, Canada: G1s 1C1 U.K.: WiP 7HE

TELEPHONE (650) Telephone number. Could be voice, data, fax, pager.

TERRITORY (651) A geographic region within a COUNTRY. Can be a State,Province, etc., e.g., California, Quebec, Gauteng, etc.

USAGE TYPE (671) Customer Domain. Details whether the address is usedfor personal or business.

ISP

FIGS. 7A through 7E illustrate an entity-relationship diagram of theINTERNET SERVICE PROVIDER (ISP) subject area of the logical data model.The ISP component view covers all aspects of Internet Service Provideractivity.

The entities of the INTERNET SERVICE PROVIDER Subject Area are definedas follows:

ISP BILLING PLAN (514) ISP Billing plan information.

ISP BILLING PLAN SERVICE (515) Information concerning an ISPs billingservices.

ISP BUSINESS CLIENT (516) Captures information concerning an ISP'sbusiness customers.

ISP BUSINESS TYPE (517) Provides information regarding the ISPs businessinterest.

ISP COMM FACILITY (518) Information concerning an ISP's communicationfacilities.

ISP COMM SERVER (519) Information regarding an ISP's communicationservers.

ISP CUST ACCT REP (520) Information regarding the customer account repsfor an ISP.

ISP CUST BILL PLAN (521) Information regarding an ISP's customer billingplans.

ISP CUST BILL REVENUE (522) Information regarding ISP's customer revenuefrom bills.

ISP CUST SVC REVENUE (523) Information regarding an ISPs customerservice revenue.

ISP CUSTOMER ACCOUNT (524) This entity represents the accounts held by acustomer.

ISP NETW ROUTER (525) ISP network router information.

ISP NETWORK FACILITY (526) Information regarding the physical facilitycomponents of an ISP's network.

ISP POP (527) ISP POP information.

ISP POP AREA (528) Information concerning an ISPs POP's areas.

ISP POP REGION (529) Information concerning an ISPs POPs regions.

ISP SERVICE CATEGORY (530) Category of services provided by an ISP.

ISP SERVICE DESC (531) Contains information regarding the types ofservices that have been provided by an ISP.

ISP SERVICE TYPE (532) Information regarding the types of servicesprovided by an ISP.

ISP SUBSCRIBER (533) This entity represents the subscribers to the ISP.

ISP SUBSCRIBER SESSION (534) Information regarding a customers session.

ITEM

Within the ITEM subject area shown in FIGS. 8A through 8D, informationis tracked on each piece of merchandise or service provided by theE-Business company. Included within the subject area tables would be adescription of each piece of merchandise or service, how the item wasclassified, price, cost, the number in inventory, etc.

The entities of the ITEM Subject Area are defined as follows:

BRAND (420) A unique name created by an ORGANIZATION to build customerrecognition and affinity for a group of related ITEMs. SomeORGANIZATIONs own many BRANDs, while others build their Corporate nameinto a BRAND, e.g., Coke, Ruffles, Wonder Bra; Dreamcast, Dockers, etc.

BRAND OWNER ORG (421) The ORGANIZATION that created, owns, and controlsa specific BRAND. For example: Nabisco, Victoria's Secret, Pepsi Co.,etc.

CHARACTERISTIC (432) Describes a trait of an ITEM, such as Color,Height, Suitable Age rating, etc.

CHARACTERISTIC GROUP (433) A cluster of relater ITEM CHARACTERISTICs.‘Size’ could be a CHARACTERISTIC GROUP, with each of the dimensions(height, width, depth) being a separate CHARACTERISTIC.

CHARACTERISTIC VALUE (434) The actual value describing the specificCHARACTERISTIC of a specific ITEM. For example: Color=‘blue’, SuitableAge rating=‘12 years and older’.

CLASS (436) A subgrouping of like merchandise, usually created along theenterprises reporting hierarchy and associated with a certain groupingof ITEMs and ASSOCIATE(s) managing said ITEMs, e.g., a ‘buyer’. A CLASSbelongs to exactly one DEPARTMENT and is considered one of the highestlevels at which purchasing and sales are planned. CLASS may be a levelmember of a retail organization's ITEM hierarchy. The actual namingconvention for PRODUCT hierarchy may vary across organizations.

DEPARTMENT (474) Represents a broad group of merchandise appealing to aparticular CUSTOMER's needs or an administrator's needs.

A DEPARTMENT represents one of the highest, if not the highest, PRODUCThierarchy levels in an organization. The actual naming convention forITEM hierarchy may vary across organizations. A DEPARTMENT may be enduse based, e.g., Women's Hosiery, or may be VENDOR based, e.g., LizClaiborne Sportswear. The scope of a DEPARTMENT will largely depend onthe size of the organization, but might typically cover twenty to thirtymanageable categories.

DIVISION (478) Represents an administrative grouping of DEPARTMENTs.DIVISIONs exist to further cluster merchandise into groups foradministrative or organizational reporting purposes. A DIVISION oftenrepresents the highest ITEM hierarchy level in an organization. Theactual naming convention for ITEM hierarchy may vary acrossorganizations.

FRANCHISE (491) A concept with consumer recognition and value. Oftenused in marketing and tie-in PROMOTIONs For example: Indiana Jones,Batman, Star Wars, Pokemon, etc.

INVENTORY CONTROL (512) A cross-reference of ITEMs to LOCATIONs for thepurpose of managing INVENTORY. It specifies the required, re-ordering,and safety levels of stock.

ITEM (535) An ITEM is the lowest level for which inventory and salesrecords are retained within the STORE. It is analogous to a SKU (StockKeeping Unit).

ITEM CHARACTERISTIC (536) The actual value describing the specificCHARACTERISTIC of a specific ITEM. An ITEM can have an unlimited numberof ITEM CHARACTERISTICs. For example the “Entrapment” Movie DVD has thefollowing ITEM CHARACTERISTICs: Aspect Ration: ‘1:2.35,’ Encoding:‘Anamorphic’, Genre: ‘Action’, Age Rating:‘12 and above’, etc.

ITEM CONTENT (537) Describes the ‘bill of material’ of an ITEM thatcontains other ITEMs. For example the “Indiana Jones Deluxe Pack”contains: I.J. Coloring Book, I.J. movie, and I.J. Action Figure.

ITEM COST (538) Cost information of an ITEM keyed by time and LOCATION.The key structure may vary as per enterprise requirements.

ITEM GROUP (539) A cluster of ITEMs grouped together for analytical ormerchandising reasons. Can be used for permanent, global, or ad-hocreasons.

ITEM GROUP XREF (540) Defines which ITEMs are contained in which GROUPs.An ITEM can be in multiple ITEM GROUPs at the same time.

ITEM PRICE (541) Pricing information of an ITEM by LOCATION. The keystructure may vary in accordance with enterprise requirements.

LEAD TIME (548) Contains information concerning inventory replenishmentfor the seasons of the year.

PRODUCT (612) A PRODUCT is a physical type of ITEM (as opposed to aSERVICE). A PRODUCT can be inventoried, and shelved.

PRODUCT INVENTORY (613) Represents history On Hand Stock position for aspecific PRODUCT, within a specific LOCATION, for a specific PERIOD.

RELATED ITEM (629) Information concerning the relationship between twoitems.

SALES PLAN (632) A detailed plan of action of how ITEMs are marketed,sold, and distributed to each STORE.

SCAN CODE (633) A barcode or similar graphic placed upon a PRODUCT andremotely scan-able (usually optically). Can be internally or externally,e.g., UPC, created. Examples include: UPC code, the scan tickets placedupon ITEMs bought in the meat, deli, and bakery departments, etc.

SERVICE (639) A non-physical type of ITEM sold to a customer. Examplesinclude: Installation of a new PC, Carpet cleaning, Repair service, etc.

STORE DEPARTMENT ITEM (646) A Cross reference of the actual ITEMs thatare sold in a specific DEPARTMENT of a specific STORE. For example:‘Store 243’ sells ‘Fuji 100 Sensia Film’ in it's ‘Photo Department’.

SUBCLASS (648) A level of the ITEM hierarchy description in a retailorganization. It is a member of exactly one CLASS. The actual namingconvention for PRODUCT hierarchy may vary across organizations.

Additional entities concerning items that are articles or publicationsthat may be included within the ITEM Subject Area are shown in FIG. 8Eand described below.

ARTICLE (705) A piece of writing, such as a magazine or newspaperarticle, provided as an ITEM for sale.

ARTICLE AUTHOR (706) Identifies the author of an ARTICLE.

ARTICLE COMPONENT (707) An entity that tracks MULTIMEDIA COMPONENTsassociated with an ARTICLE.

ARTICLE SOURCE (708) Identifies the source of an ARTICLE, such as a newsservice or publisher.

COLLECTION (709) An entity that identifies a group of ARTICLEs that arerelated.

COLLECTION ARTICLE (710) An identification of an ARTICLE that is amember of a COLLECTION.

RANK DISCRIPTOR (711) A ranking of ARTICLEs within a COLLECTION.

LOCATION

The LOCATION subject area provides for the storage of informationconcerning on all physical and virtual sites owned or leased by theretailer to support the sale of goods, distribution, and storage. Wouldinclude kiosks, warehouses, offices, as well as internet sites.

The entities of the LOCATION Subject Area, illustrated in FIGS. 9A and9B, are defined as follows:

CHAIN (430) Represents all stores owned by a CORPORATION or retailorganization, which perform the same business activity using the sameconsumer brand identity.

CHANNEL (431) The various CHANNELs in which the ITEMs are sold. ITEMprices may vary across CHANNELs., e.g., STORE (P.O.S), WEB, and CATALOG.

CORPORATION (458) The internal parent company of the enterprise's chainsor subsidiaries. A CORPORATION represents the highest level,constituting the total of all CHAINs, STOREs and DEPARTMENTs within theenterprise.

CORPORATION TYPE (459) This entity represents a classification type fora Corporation. Possible examples include Advertiser, Publisher, etc.

CORPORATION X CORPORATION TYPE (460) This entity provides for themany-to-many relationship between CORPORATION and CORPORATION type,allowing a single CORPORATION to be classified by more than oneCORPORATION TYPE.

DISTRICT (477) A grouping of STORE LOCATIONs that fall within a specificgeographic area. DISTRICT is used to organize groups of STOREs for thepurposes of planning, reporting and analysis.

ITEM X LOCATION (542) This entity provides for the many-to-manyrelationship between ITEM and LOCATION.

LABOR PLAN (543) Denotes the planned labor cost and hours for a specificPERIOD, within a specific LOCATION.

LOCATION (549) A physical or virtual site which is owned or leased bythe business to support its business operations.

LOCATION OPERATING COST (551) Denotes the planned and actual OPER COSTHISTORY by OPER COSTs, for specific PERIOD, for a DEPARTMENT within aSTORE.

LOCATION PAYMENT OPTION (552) Provides information concering a specificlocations payment options.

LOCATION TRAIT (553) A cross-reference between TRAITs and LOCATIONs,describing the specific TRAITs that belongs to a LOCATION.

LOCATION TYPE (554) Identifies the type of LOCATION, for example, STOREor DISTRIBUTION CENTER. A finer level of differentiation can also beused, for example: a Mall, Stand Alone Center, SuperStore, ClearanceWarehouse, or Mini Mall.

OPERATING COST (572) Denotes the types of OPERATING COSTs for aLOCATION. The expenditure items can include: Rent, Service Charge, Heatand Electricity, Distribution, Repairs, Facility Maintenance andGrounds, Equipment Maintenance, Security, Cleaning, Refuse,Communication—Telephone, Mail, FedEx, Bank Charges, Stationary andSupplies, and Labor.

OPERATING COST TYPE (573) Classifies the different OPERATING COSTs intological groupings. For example: utilities, office-related, maintenance,etc.

REGION (628) An intermediate organization grouping level within thegeographic hierarchy, which groups LOCATIONs. A specific regionalgeographic area of the country or county.

STORE DEPARTMENT (645) A physical area and/or clustering of ITEMs withina STORE STORE DEPARTMENT XREF (647) A cross-reference showing thespecific DEPARTMENTs within a specific STORE.

TRAIT (653) A generic construct to describe characteristics of aLOCATION.

WEB STORE SALES (696) This is an aggregating entity. If the advertiserchooses not to share detailed sales information with the advertisingservice provider (or the marketing systems integrator), then thissummary information is enough for the broadest cost-benefit analysis.Note that sales figures are not aggregated on a per-item basis. Sinceweb ads refer visitors to the web store in general, not to specificitems, it makes sense to track sales for the store as a whole.Conversely, when ads are bought with guaranteed exposure to specifictarget markets it makes sense to track store sales grouped by the samesegmentation.

MULTIMEDIA COMPONENT

FIG. 10 is an entity-relationship diagram of the MULTIMEDIA COMPONENTsubject area. The MULTIMEDIA COMPONENT subject area stores multimediaelements that can be use to construct a web page, such as ads,catalogues, etc.

The entities of the MULTIMEDIA COMPONENT subject area are defined asfollows:

AD COMPONENT (404) An associative entity that tracks MULTIMEDIACOMPONENTs involved in the creation of an AD.

COMPONENT CONTENT TYPE (438) This domain identifies the types ofmultimedia components (vs web pages) source. The COMPONENT CONTENT TYPEis prepopulated with the standard suffixes of multimedia objects.

IMAGE TYPE (501) This entity represents the type of image for aMULTIMEDIA COMPONENT that is an image, i.e., Preview or Full.

MULTIMEDIA COMPONENT (562) MULTIMEDIA COMPONENT refers to variousmultimedia elements that can be use to construct a WEB PAGE, AD,catalog, etc.

MULTIMEDIA TYPE (563) Classification scheme used to categorizeMULTIMEDIA COMPONENTs. Useful in tracking components at a summary level.

PAGE COMPONENT (576) An associative entity that tracks variouscomponents appearing on a WEB PAGE.

PRIVACY

The PRIVACY Subject Area stores information about privacy permissionsfrom individuals, households and organizations of interest to theenterprise.

The entities of the PRIVACY subject area, illustrated in FIGS. 11Athrough 11F, are defined as follows:

CONSENT OPTION (441) This is the actual opt-in and opt-out domain.Pre-Populated Domain Values include: 0-Opt Out, 1-Opt In.

CONSUMER ADDRESS CONSENT (442) This table allows for explicit consent tobe given per address. An address in this context can be the postal mailaddress, a phone number or an email address. This granularity allowsconsumers to accept marketing promotions at specific email addresses,for example their yahoo or hotmail account, but not their work address.A consumer can opt-out of phone marketing at home, but accept them byregular mail etc.

CONSUMER ADDRESS HISTORY (443) Keeps the history of changes in theconsumer_address table. A trigger may be used to keep this table up todate.

CONSUMER CATEGORY CONSENT (444) This level offers more granularity andconforms the most to P3P. P3P defines fifteen base categories. A domaintable for the different categories called PRIVACY_CATEGORY is providedto contain the base P3P categories as well as any additional customcategory the business chooses to support. The consent table for thislevel is per party per category.

CONSUMER CATEGORY HISTORY (445) Keeps the history of changes in theconsumer_category_consent table. A trigger may be provided to keep thistable up to date.

CONSUMER LEVEL CONSENT (446) The privacy option that this PARTY hasgiven his/her consent for the enterprise to make use of information.This level is used to track high level preferences per consumer. It canbe used independent of category level preferences, or in an inheritancescheme in conjunction with the lower level tables. The privacy viewsshould use the codes from this table in the absence of explicit consentsat the category level. The more detailed preferences should alwaysprevail and override the codes in this table.

CONSUMER LEVEL HISTORY (447) Keeps the history of changes in theconsumer_level_history table. A trigger may be provided to keep thistable up to date.

CONTACT INFO (448) A way to communicate with, or contact, PARTYs. It canbe MAIL ADDRESS (P.O. Box, or street), ELECTRONIC ADDRESS, or TELEPHONEnumber.

CONTACT INFO TYPE (450) Indicates if an ADDRESS is MAIL, ELECTRONIC, orTELEPHONE.

CONTACT INFO USAGE (451) Specifies the usage of an address PARENTALCONSENT (581) This table is added to support COPPA, which requiresexplicit parental consent for children under thirteen years of age. Anyweb site catering to children must offer an easy to understand privacypolicy which requires children under thirteen years of age to getparental permission before the site can use or sell any personalinformation about them. If the site does not collect such information,then the policy will simply indicate that fact. However, if the sitedoes collect such personal information COPPA requires the web site tooffer the children's parents three types of consent options: Collectionand Use Consent, Disclosure Consent and No Consent.

PARENTAL CONSENT HISTORY (582) Keeps the history of changes in theparental_consent table. A trigger may be used to keep this table up todate.

PARTY (583) Any INDIVIDUAL, HOUSEHOLD, or ORGANIZATION of interest tothe enterprise.

PARTY CONTACT INFO (585) Describes how a specific combination of ADDRESSand PARTY is used. For example: ‘123 Main Street’ is used by ‘Rachel’ as‘Ship To’; ‘310-555-2342’ is used by ‘John’ as ‘Fax number’.

POLICY DEFAULT (606) This table holds the business' privacy policydefaults. These default values can be used to automatically populate theconsumer related consent tables when the consumer accepts the defaultpolicy or in the absence of explicit consumer preferences.

POLICY DEFAULT HISTORY (607) Keeps the history of changes in the policydefault. A trigger may be provided to keep this table up to date.

POLICY SCOPE (608) The scope of a privacy policy. POLICY SCOPE allowssupport for children and adult privacy default preferences. COPPArequires only three preference options: Collection and Use, Disclosureand None. Pre-Populated Domain Values include: Under 13, Over 13.

PRIVACY CATEGORY (610) This table holds the privacy category domain. Thevalues are minimally the base P3P categories. They can be augmented byany business specific category such as employer. Pre-Populated DomainValues include: UniqueID, Purchase, Computer, Navigation, Content,State, Political, Health, Preference, Physical, Online, Financial,Interactive, Demographic, Other, Employer.

PRIVACY TYPE (611) This is a continuously expanding domain, as consumersbecome more aware of privacy. PRIVACY TYPE stores the different types ofpreferences that people can opt-in or opt-out of. Pre-Populated DomainValues include: Collection and Use, Third Party Disclosure, AffiliateDisclosure, Direct Marketing, Automated Decision, Sensitive Data, MergePII with non PII.

The PRIVACY Subject Area supports four levels of privacy granularity,which can be used independently or in a complimentary fashion. Abusiness can choose to implement at a policy default level, the consumerlevel, consumer-category level and/or consumer-address-specific level.Additional granularity to support business needs in specific verticalindustries can be added.

The Policy Default Level

At the highest level, the POLICY DEFAULT table 606 holds a business'privacy policy defaults. These default values can be used toautomatically populate the consumer related consent tables when aconsumer accepts the default policy or in the absence of explicitconsumer preferences. The POLICY SCOPE table 608 is provided to supportCOPPA. The Under13 policy only applies to three privacy types:

Collection and Use, Third Party Disclosure and Affiliate Disclosure.

The Consumer Level

The consumer level is used to track high-level preferences per consumer.The consent table for this level is the CONSUMER LEVEL CONSENT table446. The consumer level can be used independent of category levelpreferences, or in an inheritance scheme in conjunction with the lowerlevel tables. The more detailed preferences should always prevail andoverride the codes in the CONSUMER LEVEL CONSENT table 446.

The Consumer-Category Level

This level offers more granularity and conforms closely to P3P. P3Pdefines fifteen base categories. The PRIVACY CATEGORY domain table 610contains the base P3P categories as well as any additional customcategory a business chooses to support. The consent table for this levelis the CONSUMER CATEGORY CONSENT table 444 AND is per party percategory.

The Consumer-Address-Specific Level

This level allows for explicit consent to be given per address. Anaddress in this context can be the postal mail address, a phone numberor an email address. This granularity allows consumers to acceptmarketing promotions at specific email addresses, for example theiryahoo or hotmail account, but not their work address. A consumer canopt-out of phone marketing at home, but accept them by regular mail etc.The consent table for this level is the CONSUMER ADDRESS CONSENT table442.

Parental Consent

This section is added to support COPPA, which requires explicit parentalconsent for children under 13. Any web site catering to children mustoffer an easy to understand privacy policy which requires children under13 years of age to get parental permission before the site can use orsell any personal information about them. If a site does not collectsuch information, then the policy will simply indicate that. However, ifa site does collect personal information then, COPPA requires the siteowner to offer parents three types of consent options: Collection andUse Consent, Disclosure Consent and No Consent.

History Support

In order to support history tracking requirements, each privacy level aswell as the parental consent section includes a history table whichcarries exactly the same columns as the main table plus an effectivedate and an end date. The history table is updated when consent codesare inserted, updated or deleted. The most current consent codes arecontained in the main tables. The historical record population mechanicscan be implemented via database triggers, which may be implemented aspart of this LDM design. The history tables for the policy defaultlevel, the consumer level, consumer-category level,consumer-address-specific level and parental consent section are POLICYDEFAULT HISTORY table 606, CONSUMER LEVEL HISTORY table 447, CONSUMERCATEGORY HISTORY table 445, CONSUMER ADDRESS HISTORY table 443, andPARENTAL CONSENT HISTORY table 582, respectively.

PROFILE

FIGS. 12A through 12G illustrate an entity-relationship diagram of thePROFILE subject area. The PROFILE subject area stores informationconcerning customer segments of interest to the enterprise. Thisinformation is typically purchased from a third party.

The entities of the PROFILE subject area are defined as follows:

AGE RANGE (418) Information regarding age ranges.

COMPUTER INFO (439) Profile data for entity.

COMPUTER TYPE (440) Stores computer hardware type information.

CONTACT METHOD (452) Describes contact preferences.

CONTACT PERIOD (453) Information regarding preferred contact periods.

EDUCATION LEVEL (480) Information regarding education levels.

EMPLOYMENT STATUS (483) Information regarding employment statuses.

ETHNICITY (485) Information regarding ethnicity.

GENDER (495) Information concerning gender.

INCOME RANGE (503) Information regarding income ranges.

INCOME TYPE (504) Describes types of income.

INTEREST MAP (510) Contains information linking web page URLs tointerest.

LANGUAGE (544) List of language types.

LANGUAGE GROUP (545) List of language groups.

MARITAL STATUS (557) Contains information regarding marital statuses.

OCCUPATION (566) Specifies occupations.

OCCUPATION GROUP (567) Specifies occupation groups.

OCCUPATION INDUSTRY (568) Specifies organizational industries.

PARTY PROFILE (590) Information linking party entities and profiles.

PARTY TRAIT PROFILE (593) Contains information linking party entities totheir profiles, trait categories and traits with interest level scores.

PERSONAL INFO (603) Provides personal profile information.

PROFICIENCY (614) Standard Domain: Language Proficiency Level.

PROFILE INCOME (615) Income.

PROFILE INFO (616) Unique identifier for entity profile information.

PROFILE LANGUAGE GROUP (546) Information linking language, languagegroup and language proficiency.

PROFILE SOURCE (617) Specifies the source of profile information.

PROFILE TRAIT (618) Describes specific interest within a demographictype.

RECENCY BAND (624) How long ago was the last purchase made.

REFERRAL BAND (626) How many people has this person referred REVENUEBAND (631) Customer Domain to track the revenue generated by thiscustomer.

SITE ACTIVITY INFO (641) Contains information regarding activitiestracked during web visits.

TRAIT CATEGORY (654) Contains information concerning different types ofprofile information.

TRAIT GROUPING (655) Describes specific interest groupings within ademographic type.

TRANSACTION FREQUENCY BAND (663) Information regarding transactionfrequency bands.

VISIT FREQUENCY RANGE (682) Information regarding browsers visitfrequency.

YEARS AT RESIDENCE (703) Information regarding years at residence.

PROMOTION

The PROMOTION subject area contains information concerning promotions,which are defined as marketing efforts, which are different from normalpractice and designed for a specific purpose. Information is stored onthe various components of the promotion, including the items and adsincluded, the type of ad, and the market segments targeted.

The entities of the PROMOTION subject area, illustrated in FIGS. 13A and13B, are defined as follows:

CAMPAIGN (427) A marketing effort with a specific start and end date.Typically a large effort, that can consist of multiple PROMOTIONs. Thegoal of a CAMPAIGN is usually to enhance the image of the enterprise,and/or drive more business and/or obtain more customers. Example: Sonylaunches a 3-month CAMPAIGN to build brand awareness, and createsseveral consumer oriented PROMOTIONs, TV ADs, etc. to support theCAMPAIGN.

CAMPAIGN_X_PROMOTION (428) Information regarding linkage betweenpromotions and campaigns.

COUPON CERTIFICATE (464) A specific instance of a COUPON that istrackable through a unique number. The intent is to provide targetedINDIVIDUALs with trackable COUPONs that enable the customer to beidentified at redemption time, even if the redemption transaction iscash. A direct mail piece with a specific OFFER, containing a barcodewith a unique code, or an individualized e-mail code.

COUPON STATE (465) Provided for BroadVision Support.

INCENTED SEGMENT (502) A mapping of a group of SEGMENTs to a specificOFFER. An OFFER can be made to more than one SEGMENT. For example, allcustomers whose purchases declined over 50% over the last 6 months areoffered $20 off their next order. This is a calculated table, thecalculations occurring after data has been loaded into the warehouse.This could also be a Customer Domain table.

NETWORK (564) This entity represents a group of Publisher sites that anAd or Campaign is run on. Ad Networks commonly have predefined Networksthat Advertisers can choose to run their ads on. Examples include aComputers & Technology Network that would include all of the Computer &Technology related sites the Ad Network has space on, or a SportsNetwork that includes all of the networks sports related sites.

OFFER (569) A specific incentive made available to customers. The OFFERentity usually contains 2 parts: a.) condition(s) to be met, and b.) thereward for a.). For example: Buy a Macintosh G4, and get a free Epson700 printer.

OFFER TYPE (570) Customer Domain: Types of Offers.

PARTY COUPON (586) Information linking party entities; coupons andlocations.

PROMOTION (619) A narrowly defined marketing effort designed for aspecific purpose. Can be part of a larger CAMAPAIGN. A PROMOTION has aspecific start and end date. A PROMOTION can contain multiple OFFERS andADs. For example: A PROMOTION can be created to drive DVD sales. Itconsists of two OFFERS: one for free shipping, and one for 10% offorders over $100; and two2 ADs: a TV AD and a BANNER AD placed onselected websites.

SEGMENT (638) A cluster of PARTYs for marketing purposes. A SEGMENT canbe re-used, and can receive multiple OFFERs. This is a calculated table,the calculations occurring after data has been loaded into thewarehouse. This could also be a Customer Domain table.

TIME

The TIME subject area contains information concerning the time in agiven day by hours, minutes and seconds. The entities of the TIMEsubject area, illustrated in FIG. 14, are defined as follows:

CLOCK TIME (437) This entity represents a specific instance time mostlikely represented in military time. Each row indicates a particularinstance in time down to the second.

HOURS (497) This entity represents the hours of the time field.

MINUTES (558) This entity represents the minutes of the time field.

SECONDS (636) This entity represents the seconds of the time field.

TIME OF DAY (652) This entity represents a division of a day, i.e.,morning, afternoon, night, etc. This may be defined in 4 or 6 hourperiods or into however many segments the company wants to divide up aday.

TRANSACTION ACTIVITY

FIGS. 15A thorough 15E illustrate an entity-relationship diagram of theTRANSACTION ACTIVITY subject area. The TRANSACTION ACTIVITY storesinformation concerning a customer's interaction with the companyinvolving the sale or return of an item and the price and discountsassociated with that item. It maps customers to entries in the AddressArea, the item(s) of interest, and the associate dealing with thecustomer.

The entities of the TRANSACTION ACTIVITY subject area are defined asfollows:

APPROVAL STATUS (419) The outcome of a request for approval of anon-cash transaction from a financial ORGANIZATION. Examples include:confirm identity of INDIVIDUAL only, deny purchase, etc.

DISCOUNT (475) The types of reasons why the total tender required for agiven purchase may be reduced. May be based on the total SALESTRANSACTION, or can be ITEM specific. Reasons for reduction may include:loyalty card, summer sale, 2-for-1 sale, etc.

DISCOUNT TYPE (476) Denotes types of discounts, which reduce the sellingprice that is normally charged as an expense to the STORE's generalledger. Can be applied by transaction line item or to the wholetransaction.

EXTERNAL COUPON (487) An external coupon redeemed during a SHOPPINGTRANSACTION. EXTERNAL COUPONs include 3rd party coupons, such asmanufacturer's or competitor's coupons.

FULFILLMENT (492) The act of providing previously ordered or purchasedITEMs to a customer. It can be fulfilled by the enterprise or anexternal VENDOR, such as through drop shipment, etc.

FULFILLMENT LINE (493) The actual ITEMs contained in a FULFILLMENT.

FULFILLMENT STATUS (494) This entity represents the status of theFULFILLMENT to a customer. Possible values include: Complete Order OnTime, Complete Order Late, Partial Order On Time, etc.

PARTY TRANSACTION (594) Contains information associating transactions tobuyers and sellers.

PAYMENT LINE (600) A tender amount applied to a specific SALESTRANSACTION. One SALES TRANSACTION can have multiple PAYMENT LINESassociated with it.

RETURN TRANSACTION LINE (630) Details PRODUCTs returned to a LOCATION bya customer for a refund or an exchange.

TRANS CHARGE TYPE (656) Defines the types of charges that are added to aSHOPPING TRANSACTION that are not related to any particular item.Charges may include: shipping, handling, insurance, overnight, etc.

TRANSACTION ACTIVITY (657) A single CUSTOMER interaction or transactioninvolving the sale or return of one or more ITEMs.

TRANSACTION ADJUSTMENT (658) Contains information concerning transactionadjustments.

TRANSACTION CHARGE (659) Revenue obtained from customers that are notITEM related, such as shipping & handling, insurance, etc.

TRANSACTION CONTACT INFO (660) Information linking transactions tophysical locations.

TRANSACTION DISCOUNT (661) An amount that reduces the total TENDERamount required from the customer for a given purchase. This could bedue to an OFFER, coupon, sale, markdown, damaged merchandise, etc. Itcan be related to an entire SHOPPING TRANSACTION, or more specificallyrelated to ITEMs in a SHOPPING TRANSACTION LINE. Example: The amount of$3.25 to be subtracted from total tender required due to the purchase of750 ml Kahlua by a loyalty card member.

TRANSACTION DISCOUNT LINE (662) A cross-reference mapping a SHOPPINGTRANSACTION DISCOUNT to the actual ITEMs that was purchased to qualifyfor the DISCOUNT and/or the ITEMs that received the DISCOUNT. Example:Cross-reference the full retail purchase of a ‘six-pack of Coke a Cola’and the resultant 50% off ‘Dodgers baseball cap’ to the SALES DISCOUNT.

TRANSACTION LINE (664) The actual ITEMs purchased by a customer within aSALES TRANSACTION.

TRANSACTION LINE STATUS (665) This entity represents the status of aSHOPPING TRANSACTION LINE. It is used to determine whether items arecurrently in a shopping basket, have been dropped from the basket, orhave been purchased.

TRANSACTION RESPONSE (666) Captures responses based on customertransactions.

TRANSACTION RESPONSE TYPE (667) Defines the various types of customertransaction response types.

TRANSACTION STATUS (668) Denotes the current phase of a SHOPPINGTRANSACTION, such as: canceled order, abandoned shopping cart, shoppingcart that had been converted into an order, etc.

TRANSACTION TYPE (669) Differentiates a SHOPPING TRANSACTION.TRANSACTION TYPEs may include: Web Shopping Cart, Web Wish-list, StoreSale, Catalog Order, etc.

VENDOR

The VENDOR subject area stores information about parties from which thecompany purchases goods and services. This includes informationconcerning purchase orders, returns, and items shipped directly to thecompany or drop shipped to a customer.

The entities of the VENDER subject area, illustrated in FIGS. 16A and16B, are defined as follows:

VENDOR (672) An identifier of an ORGANIZATION that supplies ITEMs to acompany. This ID is mapped to a party ID. This ID can represent anindividual or a business.

VENDOR ITEM (673) Identifies which ITEMs can be obtained from whichVENDORs.

VENDOR PURCHASE ORDER (674) Represents an order placed by the enterprisefor ITEMSs to be supplied by a VENDOR.

VENDOR PURCHASE ORDER LINE (675) The detail line on the VENDOR PURCHASEORDER that provides information about the ITEM being ordered.

VENDOR PURCHASE ORDER TYP (676) Distinguishes the various types ofPURCHASE ORDERs.

VENDOR RECEIPT (677) A shipment of ordered goods from a VENDOR to theenterprise.

VENDOR RECEIPT ITEM (678) Information about a specific ITEM contained ina VENDOR RECEIPT.

VENDOR RETURN (679) ITEMs returned to the VENDOR, due to damage ormalfunctioning of the ITEM.

VENDOR RETURN REASON (680) Establishes the reasons why an ITEM may bereturned to a VENDOR. Reasons for return may include: damaged, incorrectitem, etc.

VISIT

The VISIT subject area stores information concerning a customer'shistory at a virtual store's web site. Included would be informationabout the ads that triggered the visit, the web pages browsed, and theitems of interest to the consumer.

The entities of the VISIT subject area, illustrated in FIGS. 17A through17F, are defined as follows:

BROWSER APPLICATION (422) This entity represents the internet browserapplication software family the client is running. For example: InternetExplorer, Netscape.

BROWSER APPLICATION VER (423) This entity represents the application andversion of the internet browser that the client is using to view the website. Examples include: Internet Explorer 5.0, Netscape 4.06.

CONVERSION (456) This table contains a record for the conversions thatwere recommendations from the recommendation engine. This table isprovided to support integration with recommendation engines and does notimply TSEB functions as a recommendation engine.

CONVERSION CATEGORY (457) Contains information concerning the linkagebetween recommended items and the web page the item was displayed on.

DOMAIN EXTENSION (479) This entity represents the extension of the nameof the domain server. For example: .com, net, org.

EMAIL CLIENT APPLICATION (482) This entity represents the emailapplication used by a client to read and send email, such as MicrosoftOutlook Express 5.0.

ENTRY FLAG (484) Describes the order of the pages viewed during a webvisit, such as first page, exit page, intermediate page.

EXIT METHOD (486) This entity represents the method by which the userleft a web site. This would have the value ‘timeout’ for most visits,but other values could be defined for explicit actions that result in auser exiting the site.

FILE (488) The entity represents an electronic file, for example song.mp3 file, a document .pdf file, etc.

FILE DOWNLOAD (489) The entity represents the request from a user todownload a file from a web site.

FILE TYPE (490) The entity represents the types by which a FILE may beclassified. Common file types include EXE, MP3, PDF, etc.

HTML RESPONSE FILE (500) This entity represents the actual HTML filethat is returned to the user as a result of a click.

INTERACTION (506) This entity represents activities that occur during avisit that can not be directly tied to a CLICK or set of CLICKs during aVISIT.

INTERACTION RESULT (507) Information regarding interaction results.

INTERACTION SUBTYPE (508) Information regarding interaction sub types.

INTERACTION TYPE (509) Describes the various types of interactions userscan have with an enterprise.

IP ADDRESS (513) This entity represents the Internet Protocol addressthe client requests are coming from.

PAGEVIEW (578) Loaded from weblog unless a customer has a database withthis information such as Broadvisision.

PAGEVIEW_COMPONENT (579) This table lists all the components downloadedby this PageView.

PAGEVIEW_X_INTERACTION TASK (580) This table is the output of anapplication that can examine the interactions associated with each clickand determine their outcome, e.g., purchase, abandonment etc.

PLATFORM (604) This entity represents the operating system platformfamily that the client is running. Examples: Windows 9×, Windows NT,Mac, UNIX.

PLATFORM VER (605) This entity represents the operating system platformand version the client is using. Examples: Windows 98, Windows NT 4.0.

QUERY STRING FIELD NAME (621) This entity represents the domain ofparameter names that may appear in the query string of a URL for a WEBPAGE.

QUERY STRING FIELD VALUE (622) This entity represents the domain ofparameter values that may appear in the query string of a URL for a WEBPAGE.

QUERY STRING NAME VALUE (623) This entity stores the relationshipbetween PageViews, QUERY STRING FIELD NAMEs and QUERY STRING FIELDVALUEs. It holds the set of name-value pairs from the query string ofthe URL that is associated with this PageView. The name-value pairsoften include elements such as search parameters.

RECOMMENDATION (625) This table contains a record for eachrecommendation that was made by the recommendation engine. This table isprovided to support integration with recommendation engines and does notimply TSEB functions as a recommendation engine.

REFERRAL TYPE (627) An entity used for classifying referrals intovarious sub-types such as email referrals, e-location referrals, etc.

UNIQUE VISIT (670) If a cookie does not exist in partyID then the visitis unique. If unique, then cookie_value is inserted in party partyID.

VISIT (681) A period of time that a PERSON spends at a LOCATION.

VISIT LOCATION (683) Contains information linking visits to locations.

VISITOR DOMAIN (684) This entity stores information about IP addressesfrom which customers access a retailer's web site. This is useful inproviding summary level information about various access points forcustomers such as internet service providers, public access terminals,companies, universities, government sites, etc. The information can beuseful in selecting advertisements and designing promotions.

WEB IDENTIFICATION METHOD (685) This entity represents the method bywhich the PARTY was identified for a WEB VISIT.

WEB VISIT (697) Loaded from weblog unless customer has a database withthis information such as Broadvisision.

WEB VISIT TYPE (698) This entity represents a classification of theresult derived from a WEB VISIT. Possible values include: Browse, 1stPurchase, Repeat Purchase, etc.

WEB_VISIT_FILE (699) This associative table stores all the filesdownloaded during a visit.

VISITOR

FIGS. 18A through 18E illustrate an entity-relationship diagram of theVISITOR subject area. The VISITOR subject area captures informationabout the users involved in web transactions and/or interactions. Thisarea maintains information about customer's payment accounts, andhousehold and organizational affiliations, and it maps customers toentries in the Address and Demographics Subject Areas.

The entities of the VISITOR subject area are defined as follows:

ACCOUNT STATUS (401) Information regarding account statuses.

ACTIVITY STATUS (402) This entity stores the valid states of an entity.Valid states can be active, inactive, or deleted.

BRAND OWNER ORG (421) The ORGANIZATION that created, owns, and controlsa specific BRAND. For example: Nabisco, Victoria's Secret, Pepsi Co.,etc.

CREATION SOURCE (467) An indication of how and where information aboutthe existence of a PARTY is first obtained. Sources include: a purchasedprospect list, the PARTY requested a catalog through the business'swebsite, etc.

CREDIT CARD TYPE (468) Describes a kind of credit card, such as Visa,MC, Diners, etc.

CREDIT INFO (469) Information regarding party entities credit histories.

CREDIT RATING (470) Internal or external methods for classifying aPARTY's or a PAYMENT ACCOUNT's credit worthiness. Entries may include:do not extend credit to this person, low risk, high risk, TRW score.

CUSTOMER SCORE (471) This entity represents the score a customer isgiven based on their previous behavior, and represents their likelihoodto perform some other action.

HOUSEHOLD (498) A grouping of INDIVIDUALs for marketing purposes. Theytypically live at the same ADDRESS and have biological ties, such asfamily members, e.g., the Simpson family HOUSEHOLD INDIVIDUAL (499) Agrouping of INDIVIDUALs for marketing purposes. They typically live atthe same ADDRESS and have biological ties. For example: Horner, Marge,Lisa, Bart, and Maggie.

INDIVIDUAL (505) Any human being of interest to the enterprise.

LOYALTY LEVEL (555) Loyalty program information.

ORGANIZATION (574) A sub-type of PARTY. Multiple INDIVIDUALs who haveorganized into a formal group for a common purpose.

ORGANIZATION TYPE (575) Information regarding organization types.

PARTY (583) Any INDIVIDUAL, HOUSEHOLD, or ORGANIZATION of interest tothe enterprise.

PARTY ACCOUNT (584) Information regarding accounts.

PARTY LOYALTY LEVEL (704) Loyalty program information.

PARTY PAYMENT ACCOUNT (589) Information linking party entities topayment accounts.

PARTY SEGMENT (591) A cross-reference of the actual PARTYs contained ina specific SEGMENT.

PARTY STATUS (592) This entity maintains the relationship between aPARTY and a PARTY STATUS to allow tracking of the history as the PARTYSTATUS of a PARTY changes.

PARTY TYPE (595) Contains information regarding party entity types.

PAYMENT ACCOUNT (596) An account established by a PARTY with anORGANIZATION, typically to facilitate and enable the transfer of funds.

PAYMENT ACCOUNT STATUS (597) This entity maintains the relationshipbetween a PAYMENT ACCOUNT and an ACTIVITY STATE to allow tracking of thehistory as the ACTIVITY STATE of a PAYMENT ACCOUNT changes.

PAYMENT ACCOUNT TYPE (598) Describes a kind of PAYMENT ACCOUNT, forexample: Check, Credit Card, Loyalty Card, etc.

PAYMENT TRANSFER (599) This table contains account number informationfor both source and destination accounts.

PAYMENT RECORD (601) This table contains records detailing the transferof funds between two businesses.

PERSONA (602) The ‘role’ an INDIVIDUAL is playing while interacting withthe enterprise, typically in association with an ORGANIZATION. Forexample, INDIVIDUAL Jill may posses two different PERSONAs: Jill mayorder ITEMs in her capacity as ‘owner’ of ‘Jill's Dog Grooming Co.’, orJill may call about a problem with an order in her capacity as a ‘buyer’for ABC Corporation.

SCORE TYPE (634) Describes the type of technology used to generate thescore, e.g., CART, Decision Tree, CHAD etc.

SIC (640) Standard Industry Classification Codes. A way to indicate thetype of business an ORGANIZATION is. Used for segmentation purposes bythe marketing industry.

SUPPRESSION (649) CRM support table linking suppression information toparty entities.

VENDOR (672) An identifier of an ORGANIZATION that supplies ITEMs to acompany. This ID is mapped to a party ID. This ID can represent anindividual or a business.

WEB SERVER

The WEB SERVER subject area provides summary information, operationalmetrics and errors about the physical server devices servicing a givenweb visit by a customer.

The entities of the WEB SERVER subject area, illustrated in FIG. 19, aredefined as follows:

WEB SERVER (689) Provides summary information about the physical serverdevices servicing a WEB VISIT.

WEB SERVER ACTIVITY (690) Provides WEB SERVER operational metrics.

WEB SERVER SOFTWARE (691) Captures information about the software beingutilized by the web server.

WEB SERVER STATUS (692) An entity used to provide information about WEBSERVER errors.

WEB STATUS CATEGORY (695) Domain for Web Server error

categories such as: Unknown, Informational, Successful, Redirection,Client Error.

WEB SITE

The WEB SITE subject area stores information about the company's websites including page components, page generation, and web page type.

The entities of the WEB SITE subject area are, illustrated in FIGS. 20Aand 20B, are defined as follows:

CONTEXT (454) Contains the business intent represented by web pages.

CRAWLER (466) This table contains a list of crawler sites that have a,visited the web site of the business entity.

INTERNAL FLAG (511) Usage of this table is customer specific.

NETWORK X PUBLISHER (565) A cross-reference of the actual PUBLISHERscontained in a specific NETWORK.

PAGE GENERATION TYPE (577) This entity is used to classify the methodinvolved in generating a web page. For example: static versus dynamicpage.

PARTY LOGIN (588) This entity represents the login information of aPARTY. This entity supports tracking of a PARTY's login names formultiple web sites.

SECTION TYPE (637) This entity represents a classification of thecontent for a WEB SITE SECTION similar to sections of a newspaper. A WEBSITE may be divided into several sections based on the content of thepages. For example, one section may be sports related content whileanother may be finance related.

SITE CONTENT TYPE (642) This entity represents a classification of thecontent of a WEB SITE. Possible SITE CONTENT TYPEs include Sports, News,Portal, etc.

SITE LOCALE (643) This entity represents the nationality or locale the aWEB SITE is designed for, e.g., Yahoo Germany or Yahoo Spain.

WEB PAGE (686) Source: Weblog->URL_Stem Frame presented after a click.It will be identified as any URL in the click records which does nothave a component suffix with a web_page_flag to be set in weblog. URLsin weblog->referrer origin are recorded here also, as they arereferenced in the click table.

WEB PAGE CONTEXT (687) Links the context for which the web page is beingrendered.

WEB PAGE REGION (688) This entity represents areas in which a WEB PAGEmay be divided. Examples include: TOP, BOTTOM, TOP-LEFT.

WEB SITE (693) This entity represents a collection of WEB PAGES under asingle domain name.

WEB SITE SECTION (694) This entity represents divisions of a WEB SITE,such as Yahoo Sports or Yahoo Finance, in order to divide large WEBSITES into smaller divisions of related WEB PAGES that contain similarcontent.

CONCLUSION

The Figures and description of the invention provided above, reveal aflexible relational data model for E-Business businesses. The E-BusinessLogical Data Model (E-LDM) design includes an extensible data model thatsupports current privacy laws and conventions and which can be readilyapplied anywhere an E-Business retailer conducts business.

This design supports four levels of privacy granularity, which can beused independently or in a complementary fashion. An E-Business retailercan choose to implement at a policy default level, the consumer level,consumer category level and/or consumer-address-specific level.Additional granularity to support business needs in specific verticalindustries can be added. All fifteen of the basic P3P privacy categoriesare implemented in this design.

The foregoing description of the preferred embodiment of the inventionhas been presented for the purposes of illustration and description. Itis not intended to be exhaustive or to limit the invention to theprecise form disclosed. Many modifications and variations are possiblein light of the above teaching. It is intended that the scope of theinvention be limited not by this detailed description, but rather by theclaims appended hereto.

1. A database system for storing and managing information for anE-Business retailer, said information including information obtainedfrom and about customers and potential customers of said E-Businessretailer, said information being organized within said database systemin accordance with a logical data model, said logical data modelincluding: a subject area including a plurality of entities andrelationships defining the manner in which privacy policy and privacyconsent information governing the collection and use of information fromand about customers and potential customers by said E-Business retaileris stored and organized within a database; wherein said subject areaincludes: an entity including attributes relating to privacy consentdefault values for customers and potential customers of said E-Businessretailer; an entity including attributes relating to high-level privacyconsent values selected by said customers and potential customers ofsaid E-Business retailer; an entity including attributes relating toprivacy consent values selected by said customers and potentialcustomers for a plurality of privacy categories defined by the Platformfor Privacy Preference (P3P); and an entity including attributesrelating to privacy consent values selected by said customers andpotential customers for different addresses of said customers andpotential customers.
 2. The database system in accordance with claim 1,wherein said customers and potential customers includes children underthirteen years of age, said subject area further including: an entityincluding attributes relating to parental privacy consent values forsaid children under thirteen years of age.
 3. The database system inaccordance with claim 2, wherein said parental privacy consent valuescomprise Collection and Use Consent, Disclosure Consent and No Consent.4. The database system in accordance with claim 1, wherein said privacyconsent values selected by said customers and potential customers fordifferent addresses of said customers and potential customers comprise:different consent values for different postal mail addresses of acustomer; different consent values for different phone numbers of acustomer; and different consent values for different email addresses ofa customer.
 5. The database system in accordance with claim 1, saidsubject are further comprising: an entity including attributes relatingto a history of changes to said privacy consent default values for saidcustomers and potential customers of said E-Business retailer; an entityincluding attributes relating to a history of changes to said high-levelprivacy consent values selected by said customers and potentialcustomers of said E-Business retailer; an entity including attributesrelating to a history of changes to said privacy consent values selectedby said customers and potential customers for a plurality of privacycategories defined by the Platform for Privacy Preference (P3P); and anentity including attributes relating to a history of changes to saidprivacy consent values selected by said customers and potentialcustomers for different addresses of said customers and potentialcustomers.
 6. The database system in accordance with claim 2, saidsubject are further comprising: an entity including attributes relatingto a history of changes to said parental privacy consent values for saidchildren under thirteen years of age.
 7. A database system for storingand managing information for an E-Business retailer, said informationincluding information obtained from and about customers and potentialcustomers of said E-Business retailer, database system comprising: alogical data model including a plurality of entities and relationshipsdefining the manner in which privacy policy and privacy consentinformation governing the collection and use of information from andabout customers and potential customers by said E-Business retailer isstored and organized within a database; a database table within saiddatabase containing privacy consent default values for customers andpotential customers of said E-Business retailer; a database table withinsaid database containing high-level privacy consent values selected bysaid customers and potential customers of said E-Business retailer; adatabase table within said database containing privacy consent valuesselected by said customers and potential customers for a plurality ofprivacy categories defined by the Platform for Privacy Preference (P3P);and a database table within said database containing privacy consentvalues selected by said customers and potential customers for differentaddresses of said customers and potential customers.
 8. The databasesystem in accordance with claim 7, wherein said customers and potentialcustomers includes children under thirteen years of age, said databasesystem further comprising: a database table within said databasecontaining parental privacy consent values for said children underthirteen years of age.
 9. The database system in accordance with claim7, further comprising: a database table within said database containinga history of changes to said privacy consent default values forcustomers and potential customers of said E-Business retailer; adatabase table within said database containing a history of changes tosaid high-level privacy consent values selected by said customers andpotential customers of said E-Business retailer; a database table withinsaid database containing a history of changes to said privacy consentvalues selected by said customers and potential customers for aplurality of privacy categories defined by the Platform for PrivacyPreference (P3P); and a database table within said database containing ahistory of changes to said privacy consent values selected by saidcustomers and potential customers for different addresses of saidcustomers and potential customers.
 10. The database system in accordancewith claim 8, further comprising: a database table within said databasecontaining a history of changes to said parental privacy consent valuesfor said children under thirteen years of age.
 11. A customerrelationship management system for storing and managing information foran E-Business retailer, said customer relationship management systemcomprising: a database for storing and organizing information obtainedfrom and about customers and potential customers of said E-Businessretailer; a logical data model defining the manner in which saidinformation is stored and related within said database; and a subjectarea within said logical data model including a plurality of entitiesand relationships defining the manner in which privacy policy andprivacy consent information governing the collection and use ofinformation from and about customers and potential customers by saidE-Business retailer is stored and organized within a database; whereinsaid subject area includes: an entity including attributes relating toprivacy consent default values for customers and potential customers ofsaid E-Business retailer; an entity including attributes relating tohigh-level privacy consent values selected by said customers andpotential customers of said E-Business retailer; an entity includingattributes relating to privacy consent values selected by said customersand potential customers for a plurality of privacy categories defined bythe Platform for Privacy Preference (P3P); and an entity includingattributes relating to privacy consent values selected by said customersand potential customers for different addresses of said customers andpotential customers.
 12. The customer relationship management system inaccordance with claim 11, wherein said customers and potential customersincludes children under thirteen years of age, said subject area furtherincluding: an entity including attributes relating to parental privacyconsent values for said children under thirteen years of age.
 13. Thecustomer relationship management system in accordance with claim 12,wherein said parental privacy consent values comprise Collection and UseConsent, Disclosure Consent and No Consent.
 14. The customerrelationship management system in accordance with claim 11, wherein saidprivacy consent values selected by said customers and potentialcustomers for different addresses of said customers and potentialcustomers comprise: different consent values for different postal mailaddresses of a customer; different consent values for different phonenumbers of a customer; and different consent values for different emailaddresses of a customer.
 15. A customer relationship management systemfor storing and managing information for an E-Business retailer, saidcustomer relationship management system comprising: a database forstoring and organizing information obtained from and about customers andpotential customers of said E-Business retailer; a logical data modeldefining the manner in which said information is stored and relatedwithin said database, said logical data model including a plurality ofentities and relationships defining the manner in which privacy policyand privacy consent information governing the collection and use ofinformation from and about customers and potential customers by saidE-Business retailer is stored and organized within said database; adatabase table within said database containing privacy consent defaultvalues for customers and potential customers of said E-Businessretailer; a database table within said database containing high-levelprivacy consent values selected by said customers and potentialcustomers of said E-Business retailer; a database table within saiddatabase containing privacy consent values selected by said customersand potential customers for a plurality of privacy categories defined bythe Platform for Privacy Preference (P3P); and a database table withinsaid database containing privacy consent values selected by saidcustomers and potential customers for different addresses of saidcustomers and potential customers.
 16. The customer relationshipmanagement system in accordance with claim 15, wherein said customersand potential customers includes children under thirteen years of age,said customer relationship management system further comprising: adatabase table within said database containing parental privacy consentvalues for said children under thirteen years of age.
 17. The customerrelationship management system in accordance with claim 15, furthercomprising: a database table within said database containing a historyof changes to said privacy consent default values for customers andpotential customers of said E-Business retailer; a database table withinsaid database containing a history of changes to said high-level privacyconsent values selected by said customers and potential customers ofsaid E-Business retailer; a database table within said databasecontaining a history of changes to said privacy consent values selectedby said customers and potential customers for a plurality of privacycategories defined by the Platform for Privacy Preference (P3P); and adatabase table within said database containing a history of changes tosaid privacy consent values selected by said customers and potentialcustomers for different addresses of said customers and potentialcustomers.
 18. The customer relationship management system in accordancewith claim 16, further comprising: a database table within said databasecontaining a history of changes to said parental privacy consent valuesfor said children under thirteen years of age.
 19. A method for managinginformation for an E-Business retailer, said method comprising the stepsof: establishing a database for storing and organizing informationobtained from and about customers and potential customers of saidE-Business retailer; and establishing a logical data model defining themanner in which said information obtained from and about said customersand potential customers is stored and related within said database; andestablishing within said logical data model a plurality of entities andrelationships defining the manner in which privacy policy and privacyconsent information governing the collection and use of information fromand about said customers and potential customers by said E-Businessretailer is stored and organized within a database; wherein saidplurality of entities includes: an entity including attributes relatingto privacy consent default values for customers and potential customersof said E-Business retailer; an entity including attributes relating tohigh-level privacy consent values selected by said customers andpotential customers of said E-Business retailer; an entity includingattributes relating to privacy consent values selected by said customersand potential customers for a plurality of privacy categories defined bythe Platform for Privacy Preference (P3P); and an entity includingattributes relating to privacy consent values selected by said customersand potential customers for different addresses of said customers andpotential customers.
 20. The method in accordance with claim 19, whereinsaid customers and potential customers includes children under thirteenyears of age, said plurality of entities further including: an entityincluding attributes relating to parental privacy consent values forsaid children under thirteen years of age.
 21. The method in accordancewith claim 20, wherein said parental privacy consent values compriseCollection and Use Consent, Disclosure Consent and No Consent.
 22. Themethod in accordance with claim 19, wherein said privacy consent valuesselected by said customers and potential customers for differentaddresses of said customers and potential customers comprise: differentconsent values for different postal mail addresses of a customer;different consent values for different phone numbers of a customer; anddifferent consent values for different email addresses of a customer.